package com.pro.mapper;

import com.pro.pojo.JsBeforeUser;
import com.pro.pojo.JsMonthCount;
import org.apache.ibatis.annotations.Param;
import org.omg.PortableInterceptor.INACTIVE;
import org.springframework.security.core.parameters.P;

import java.util.List;
import java.util.Map;

/**
 * ClassName:JsBeforeUserMapper
 * Package:com.pro.mapper
 * Description:
 *
 * @Date:2021/11/13 14:49
 * @Author: ZPT
 */
public interface JsBeforeUserMapper {

    /**
     *
     * @author ZPT
     * @date 2021/11/13 14:49
     * @content :查询用户
     */
    List<JsBeforeUser> getBeforeUserTable();
    /**
     *
     * @author ZPT
     * @date 2021/11/13 15:08
     * @content :查询总数
     */
    int count();

    /**
     *
     * @author ZPT
     * @date 2021/11/13 18:12
     * @content :修改用户账号状态
     */
    Integer updateStatus(@Param("userId")Integer userId,@Param("status")Integer status);

    /**
     *
     * @author ZPT
     * @date 2021/11/14 19:16
     * @content :用户的搜索
     */
    List<JsBeforeUser> getSearchBeforeUser(@Param("account")String account,@Param("createDate")String createDate,@Param("nickname")String nickname);

    /**
     *
     * @author ZPT
     * @date 2021/11/14 20:54
     * @content :封停用户
     */
    Integer delBeforeUser(Integer userId);

    /**
     *
     * @author ZPT
     * @date 2021/11/15 10:40
     * @content :高级搜索
     */
    List<JsBeforeUser> getRetrievalTable(@Param("userCode")String userCode,@Param("consumption")String consumption,@Param("studyDate")Integer studyDate);

    /**
     *
     * @author ZPT
     * @date 2021/11/15 11:54
     * @content :单个查询
     */
    JsBeforeUser getinformation(Integer userId);

    /**
     *
     * @author ZPT
     * @date 2021/11/15 16:14
     * @content :修改用户
     */
    Integer updateBeforeUser(JsBeforeUser jsBeforeUser);
    /**
     *
     * @author ZPT
     * @date 2021/11/23 19:13
     * @content :查询非进思用户
     */
    List<JsBeforeUser> getNonUserDevelopment(@Param("account")String account,@Param("createDate")String createDate,
                                             @Param("nickname")String nickname,@Param("userCode")String userCode,
                                             @Param("consumption")String consumption,@Param("studyDate")Integer studyDate);
    /**
     *
     * @author ZPT
     * @date 2021/11/25 13:50
     * @content :根据id查询非进思用户
     */
    JsBeforeUser getNonUserDevelopmentById(@Param("userId")Integer userId,@Param("consumption")String consumption);
    /**
     *
     * @author ZPT
     * @date 2021/11/25 14:39
     * @content :零消费用户列表
     */
    List<JsBeforeUser> getZeroConsumeUser();
    /**
     *
     * @author ZPT
     * @date 2021/12/1 19:52
     * @content :查询每个月对应有多少个用户
     */
    List<JsMonthCount> countMonth();
    /**
     *
     * @author ZPT
     * @date 2021/12/6 14:54
     * @content :昨日新增人数
     */
    int yesterdayAddCount();
    /**
     *
     * @author ZPT
     * @date 2021/12/6 14:56
     * @content :当时新增人数
     */
    int todayAddCount();
    /**
     *
     * @author ZPT
     * @date 2021/12/6 14:56
     * @content :本月新增人数
     */
    int monthAddCount();
}
